These are the tables and fields involved in EXPOCAD:
Expo_Control
Stored in System_Params where ParameterName = Expo_Control. Additional fields have been added to the Expo_Control table. These fields will be used in the Expo System Setup window.
Column Name |
Data Type/Size |
Description |
---|---|---|
UseQtyOrSqrFt |
Boolean |
0 if using Quantity 1 if using Area (Square Units) |
ImportRunning |
Boolean |
1 if import is running |
ExpoCad_Prod
Stores the product mapping between EXPOCAD and iMIS.
Column Name |
Data Type/Size |
Description |
---|---|---|
MEET_ID |
Char(10) |
Event in EXPOCAD Exposition code in iMIS |
ExpoCad_Type |
Char(40) |
Booth Type in EXPOCAD Island, Peninsula, Corner, Inline, Custom and Aisle Booth |
Product_Code |
Char(31) |
Exposition 'Booth' product code |
Premium_1 |
Char(31) |
Exposition 'Other' or 'Paid Pass' product code |
Qty_1 |
Numeric |
Quantity for Premium_1 |
Premium_2 |
Char(31) |
Exposition 'Other' or 'Paid Pass' product code |
Qty_2 |
Numeric |
Quantity for Premium_2 |
Meet_Master
Additional field has been added.
Column Name |
Data Type/Size |
Description |
---|---|---|
Meet_Category |
Numeric |
0 if iMIS exposition 1 if EXPOCAD exposition |
Exhb_Booth
Additional field has been added.
Column Name |
Data Type/Size |
Description |
---|---|---|
Booth_Type |
Char(40) |
Stores the Booth Type from EXPOCAD |
EXPOCAD: ExpoCadExp
A FoxPro database file created when an event in EXPOCAD is initially setup.
Column Name |
Data Type/Size |
Description |
---|---|---|
Count_Val |
Numeric(18) |
Value of the current counter. Equal to 0 when Proc_Desc ='iMISCounter' |
UniqueID |
Numeric(18) |
Unique ID generated from the increment of Count_Val |
Orig_Booth |
Char(20) |
Original Booth Number |
New_Booth |
Char(20) |
New Booth Number |
Booth_Size |
Numeric(18) |
Size of booth in square units |
Booth_Type |
Char(40) |
Booth Type in EXPOCAD Island, Peninsula, Corner, Inline, Custom and ab |
Exhb_ID |
Char(20) |
Exhibitor ID |
Event_Name |
Char(20) |
Event name in EXPOCAD Exposition name in iMIS |
Proc_Desc |
Char(100) |
Description of EXPOCAD activity 'Rent Booth','Unrent Booth','Booth Num Change','Booth Class Change', and 'iMISCounter' |
Insert_Dat |
Char(22) |
Date record was added in EXPOCAD stored in CCYYMMDD HH:MM:SS format |
Retrv_By |
Char(100) |
Upon successful import, stores the UserID+RetrieveDate, marking that line for deletion. If the record fails the import, stores FAIL_UserID+RetrieveDate |
10.6 Production Release. Updated 8/12/2005 2:37:39 PM
Copyright © by Advanced Solutions International, Inc.
All rights reserved.